Loading the Data File and Creating the Application
Final Dashboard should look like this:
1- Downloading the data File:
Download the excel file to location of your choice and
Extract the zip file.
2- Create the Application:
a-
Open Qlik Sense app and click "Create New App"
b-
Name The application we name it "Global Superstore dashboard''
3-Loading the file to Qlik database:
a-
Click to open the application
b-
Click on Add Data files and other sources
c-
From the left side select from my computer
d- Select the path file or look for the file by selecting C/User/computer's name and then look for the file location
4-Create associations, or relationships, between the tables:
a. Drag
the dimension tables to the Fact table to create associations
b. Make sure the associations are matched with the proper Serial Key. Below are the associations.
Select only the three tables Order, People, and Returns
Note: Master Calendar will be loaded separately
Please go to the Master Calendar steps, to load the Master Calendar extension
Your final association keys should look like this:
This is what what you will create at the end of the project :